SAS - Automatic Bill of Materials (BOM) Costing

Automatic BOM Costing

Sapphire

The Sapphire developed SAS-Automatic BOM Costing utility is designed to automatically cost all BOMs on a system, and also to clear up the history of BOM costs in order to prevent the database size growing unnecessarily.

The BOM costing utility is a command line application which is typically run on a schedule using windows scheduler. The utility runs in 3 stages as follows:

Stage 1

BOM cost history is deleted if the d parameter is supplied. Costs older than the specified number of days are deleted.

Stage 2

The cost price for all stock items are updated using the last price paid (determined as last non zero price from purchase orders or supplier list price if default supplier is linked to use this)

New BOM costs are generated. All BOMs are iterated and a cost is generated for each one.

Stage 3

Subsequently the standard cost for the related stock item is set to the cost of the BOM as calculated.

Input Parameters

In order to function certain parameters must be passed into the utility via the command line, as described below:

Parameter Description Note
  u Username Required
  p Password Required
  c Company name Required
  d Delete BOM costs older than (days) Optional. If not supplied no cost history is deleted
  r Reset after… (triggers the system to clean up memory usage to prevent excessive usage) Optional, defaults to 100
  l Log every… (causes a log entry to be made to the application log in order to show progress) Optional, defaults to 1000

 

For example the utility may be run using the following command line action:

BomCost.exe u:User p:Password c:Demo l:200 d:365

Automatic BOM Costing - Downloadable Specification and User Guide

Get in touch with us 

If you would like more information on SAS-Automatic BOM Costing or any of our products/services here at Sapphire, a quick-quote or would just like to have a talk with one of our Sales team, please do not hesitate to get in touch with us via the Form provided on the right, email us at sales@saslimited.com or call us on 0845 130 9696 

Sapphire Newsletter

Sign up now to receive all the latest news & offers from Sapphire!

Previous Newsletters

Have a question for us ??

Be it anything from a quick query to a free demo, just fill in the form below to get in touch!